My answer:
The problem isn't what are the methods (see BAAN's
recommendation) but what does the methods return!
When you'll get it up I hope the next information will be very useful
for you:
Baan side (bshell) - BAAN library: tccomtest | MS Excel side (ActiveX object) |
FUNCTION extern long test21sr(ref
string slowo())
{ long numer myhardcopy("test21sr") slowo = "returned string" return(21) } FUNCTION void myhardcopy(string
filename(128))
|
Dim MyBaanObj As Object
Dim B_function As String Dim shift_no As Long Dim warhouse_no As String Dim strTemp As String Sub ShiftStart()
'IUnknown
Release
CannotCreateBaan:
BaanAutomationError:
End Sub |
And more: In BAAN libraries function it's reasonably to return a start
position.
Doing it you can write so:
MyBaanObj.ParseExecFunction "otccomtest",
B_function
nStartPos = VAL(MyBaanObj.ReturnValue)
IF nStartPos > 0 THEN
warhouse_no = Mid(MyBaanObj.FunctionCall,
nStartPos,16)
' warhouse_no="returned string"
ENDIF
Good luck!
PeterS.